SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 37720: SAS® Web Report Studio report fails to open if any data item in the information map does not have a default aggregation specified

DetailsHotfixAboutRate It

When you display a report in SAS Web Report Studio, you might see an error message that is similar to the following:

Missing report element
An error occurred in processing the report element. Please refresh the page to try again. Contact your administrator if this problem persists. 
[a12573501530360.20852686736019155_0_0] Error Rendering the Report

When you view details, one of the following root causes will likely display:

Root Cause:   java.lang.NullPointerException
	at com.sas.report.render.util.IqDataWrapper.getMeasureResultItemsWithFunctions(IqDataWrapper.java:96)
	at com.sas.report.render.optimizer.models.DefaultChildQueryAnalyzer.collectDataItemToFunctionNameIds(DefaultChildQueryAnalyzer.java:174)
	at com.sas.report.render.optimizer.models.DefaultChildQueryAnalyzer.canAggregateOnParentWithoutSplitDataItems(DefaultChildQueryAnalyzer.java:103)
	at com.sas.report.render.optimizer.models.DefaultOptimizationDataModel.canAggregateOnParentWithoutSplitDataItems(DefaultOptimizationDataModel.java:640)


Root Cause:   java.lang.NullPointerException
	at com.sas.report.render.optimizer.models.collections.DefaultDataItemMapper.getParentItem(DefaultDataItemMapper.java:156)
	at com.sas.report.render.optimizer.models.collections.DefaultDataItemMapper.getOptimizedDataItem(DefaultDataItemMapper.java:125)
	at com.sas.report.render.optimizer.models.collections.DefaultDataItemMapper.getOptimizedDataItem(DefaultDataItemMapper.java:117)
	at com.sas.report.render.optimizer.util.ExpressionResolverUtil.findInAddedResultItems(ExpressionResolverUtil.java:757)

This error can appear for promoted reports and for new reports if the multi-edit feature is used to change data item properties in the information map.

As a workaround, follow these steps:

  1. In SAS Information Map Studio, open the information map.
  2. Open the properties for each data item. Do not use the multi-edit feature.
    • For measures, and make sure that the Default aggregate function has a value.
    • For categories, make sure that COUNT(argument) is displayed (but grayed-out) in the Default aggregate function list.
    • image label

      If it is not, then select the Measure radio button and then switch back to Category. COUNT(argument) should now be filled in.

      image label

  3. Save the information map.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Change in behavior from release 3.1

The behavior in SAS Web Report Studio 3.1 is different, which means that reports that rendered correctly in 3.1 might not render after promotion. SAS Web Report Studio 3.1 does not fail if the default aggregation method is not filled in.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Web Report StudioMicrosoft Windows Server 2003 Standard Edition4.24.2_M29.2 TS2M09.2 TS2M3
Microsoft Windows Server 2003 Enterprise Edition4.24.2_M29.2 TS2M09.2 TS2M3
Microsoft Windows Server 2003 Datacenter Edition4.24.2_M29.2 TS2M09.2 TS2M3
z/OS4.24.2_M29.2 TS2M09.2 TS2M3
Microsoft® Windows® for x644.24.2_M29.2 TS2M09.2 TS2M3
Microsoft Windows XP Professional4.24.2_M29.2 TS2M09.2 TS2M3
Windows Vista4.24.2_M29.2 TS2M09.2 TS2M3
64-bit Enabled AIX4.24.2_M29.2 TS2M09.2 TS2M3
64-bit Enabled Solaris4.24.2_M29.2 TS2M09.2 TS2M3
HP-UX IPF4.24.2_M29.2 TS2M09.2 TS2M3
Linux for x644.24.2_M29.2 TS2M09.2 TS2M3
Solaris for x644.24.2_M29.2 TS2M09.2 TS2M3
SAS SystemSAS Information Map StudioWindows Vista4.24.2_M29.2 TS2M09.2 TS2M3
Microsoft Windows XP Professional4.24.2_M29.2 TS2M09.2 TS2M3
Microsoft Windows Server 2003 Standard Edition4.24.2_M29.2 TS2M09.2 TS2M3
Microsoft Windows Server 2003 Enterprise Edition4.24.2_M29.2 TS2M09.2 TS2M3
Microsoft Windows Server 2003 Datacenter Edition4.24.2_M29.2 TS2M09.2 TS2M3
Microsoft® Windows® for x644.24.2_M29.2 TS2M09.2 TS2M3
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.